load data
truncate                                       
into table CRST_PO_LINE_LOCATIONS_ALL
fields terminated by "	"                      
trailing nullcols 
( LINE_LOCATION_ID                ,
  LAST_UPDATE_DATE                Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY                 ,
  PO_HEADER_ID                    ,
  PO_LINE_ID                      ,
  LAST_UPDATE_LOGIN               ,
  CREATION_DATE                   Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY                      ,
  QUANTITY                        ,
  QUANTITY_RECEIVED               ,
  QUANTITY_ACCEPTED               ,
  QUANTITY_REJECTED               ,
  QUANTITY_BILLED                 ,
  QUANTITY_CANCELLED              ,
  UNIT_MEAS_LOOKUP_CODE           ,
  PO_RELEASE_ID                   ,
  SHIP_TO_LOCATION_ID             ,
  SHIP_VIA_LOOKUP_CODE            ,
  NEED_BY_DATE                    Date "YYYYMMDD HH24:MI:SS",
  PROMISED_DATE                   Date "YYYYMMDD HH24:MI:SS",
  LAST_ACCEPT_DATE                Date "YYYYMMDD HH24:MI:SS",
  PRICE_OVERRIDE                  ,
  ENCUMBERED_FLAG                 ,
  ENCUMBERED_DATE                 Date "YYYYMMDD HH24:MI:SS",
  UNENCUMBERED_QUANTITY           ,
  FOB_LOOKUP_CODE                 ,
  FREIGHT_TERMS_LOOKUP_CODE       ,
  TAXABLE_FLAG                    ,
  TAX_NAME                        ,
  ESTIMATED_TAX_AMOUNT            ,
  FROM_HEADER_ID                  ,
  FROM_LINE_ID                    ,
  FROM_LINE_LOCATION_ID           ,
  START_DATE                      Date "YYYYMMDD HH24:MI:SS",
  END_DATE                        Date "YYYYMMDD HH24:MI:SS",
  LEAD_TIME                       ,
  LEAD_TIME_UNIT                  ,
  PRICE_DISCOUNT                  ,
  TERMS_ID                        ,
  APPROVED_FLAG                   ,
  APPROVED_DATE                   Date "YYYYMMDD HH24:MI:SS",
  CLOSED_FLAG                     ,
  CANCEL_FLAG                     ,
  CANCELLED_BY                    ,
  CANCEL_DATE                     Date "YYYYMMDD HH24:MI:SS",
  CANCEL_REASON                   ,
  FIRM_STATUS_LOOKUP_CODE         ,
  FIRM_DATE                       Date "YYYYMMDD HH24:MI:SS",
  ATTRIBUTE_CATEGORY              ,
  ATTRIBUTE1                      ,
  ATTRIBUTE2                      ,
  ATTRIBUTE3                      ,
  ATTRIBUTE4                      ,
  ATTRIBUTE5                      ,
  ATTRIBUTE6                      ,
  ATTRIBUTE7                      ,
  ATTRIBUTE8                      ,
  ATTRIBUTE9                      ,
  ATTRIBUTE10                     ,
  UNIT_OF_MEASURE_CLASS           ,
  ENCUMBER_NOW                    ,
  ATTRIBUTE11                     ,
  ATTRIBUTE12                     ,
  ATTRIBUTE13                     ,
  ATTRIBUTE14                     ,
  ATTRIBUTE15                     ,
  INSPECTION_REQUIRED_FLAG        ,
  RECEIPT_REQUIRED_FLAG           ,
  QTY_RCV_TOLERANCE               ,
  QTY_RCV_EXCEPTION_CODE          ,
  ENFORCE_SHIP_TO_LOCATION_CODE   ,
  ALLOW_SUBSTITUTE_RECEIPTS_FLAG  ,
  DAYS_EARLY_RECEIPT_ALLOWED      ,
  DAYS_LATE_RECEIPT_ALLOWED       ,
  RECEIPT_DAYS_EXCEPTION_CODE     ,
  INVOICE_CLOSE_TOLERANCE         ,
  RECEIVE_CLOSE_TOLERANCE         ,
  SHIP_TO_ORGANIZATION_ID         ,
  SHIPMENT_NUM                    ,
  SOURCE_SHIPMENT_ID              ,
  SHIPMENT_TYPE                   ,
  CLOSED_CODE                     ,
  REQUEST_ID                      ,
  PROGRAM_APPLICATION_ID          ,
  PROGRAM_ID                      ,
  PROGRAM_UPDATE_DATE             Date "YYYYMMDD HH24:MI:SS",
  USSGL_TRANSACTION_CODE          ,
  GOVERNMENT_CONTEXT              ,
  RECEIVING_ROUTING_ID            ,
  ACCRUE_ON_RECEIPT_FLAG          ,
  CLOSED_REASON                   ,
  CLOSED_DATE                     Date "YYYYMMDD HH24:MI:SS",
  CLOSED_BY                       ,
  ORG_ID                          ,
  QUANTITY_SHIPPED                ,
  GLOBAL_ATTRIBUTE_CATEGORY       ,
  GLOBAL_ATTRIBUTE1               ,
  GLOBAL_ATTRIBUTE2               ,
  GLOBAL_ATTRIBUTE3               ,
  GLOBAL_ATTRIBUTE4               ,
  GLOBAL_ATTRIBUTE5               ,
  GLOBAL_ATTRIBUTE6               ,
  GLOBAL_ATTRIBUTE7               ,
  GLOBAL_ATTRIBUTE8               ,
  GLOBAL_ATTRIBUTE9               ,
  GLOBAL_ATTRIBUTE10              ,
  GLOBAL_ATTRIBUTE11              ,
  GLOBAL_ATTRIBUTE12              ,
  GLOBAL_ATTRIBUTE13              ,
  GLOBAL_ATTRIBUTE14              ,
  GLOBAL_ATTRIBUTE15              ,
  GLOBAL_ATTRIBUTE16              ,
  GLOBAL_ATTRIBUTE17              ,
  GLOBAL_ATTRIBUTE18              ,
  GLOBAL_ATTRIBUTE19              ,
  GLOBAL_ATTRIBUTE20              ,
  COUNTRY_OF_ORIGIN_CODE          ,
  TAX_USER_OVERRIDE_FLAG          ,
  MATCH_OPTION                    ,
  TAX_CODE_ID                     ,
  CALCULATE_TAX_FLAG              ,
  CHANGE_PROMISED_DATE_REASON     ,
  NOTE_TO_RECEIVER                ,
  SECONDARY_QUANTITY              ,
  SECONDARY_UNIT_OF_MEASURE       ,
  PREFERRED_GRADE                 ,
  SECONDARY_QUANTITY_RECEIVED     ,
  SECONDARY_QUANTITY_ACCEPTED     ,
  SECONDARY_QUANTITY_REJECTED     ,
  SECONDARY_QUANTITY_CANCELLED    ,
  VMI_FLAG                        ,
  CONSIGNED_FLAG                  ,
  RETROACTIVE_DATE                Date "YYYYMMDD HH24:MI:SS",
  SUPPLIER_ORDER_LINE_NUMBER      
)
